C:\Users\cubes>cd C:\xampp\mysql\bin

C:\xampp\mysql\bin>mysql -u root -p
Enter password: (PRESS ENTER KEEP BLANK)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
+--------------------+
EMPTY SET (0.30 sec)

mysql> CREATE DATABASE `nb158d`;
Query OK, 1 row affected (0.31 sec)

mysql> USE `nb158d`;
Database changed
mysql> SHOW TABLES;
Empty set (0.00 sec)

mysql> CREATE TABLE `practice`(
     `id` INT AUTO_INCREMENT PRIMARY KEY,
     `name` VARCHAR(80),
     `email` VARCHAR(100),
     `password` VARCHAR(80),
     `register_DATE` DATETIME,
     `modified_date` TIMESTAMP,
     `status`ENUM('0','1')
     );
Query OK, 0 rows affected (0.34 sec)

mysql> DESC `practice`;
+---------------+---------------+------+-----+-------------------+-----------------------------+
| Field         | Type          | Null | Key | Default           | Extra                       |
+---------------+---------------+------+-----+-------------------+-----------------------------+
| id            | int(11)       | NO   | PRI | NULL              | auto_increment              |
| name          | varchar(80)   | YES  |     | NULL              |                             |
| email         | varchar(100)  | YES  |     | NULL              |                             |
| password      | varchar(80)   | YES  |     | NULL              |                             |
| register_DATE | datetime      | YES  |     | NULL              |                             |
| modified_date | timestamp     | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| status        | enum('0','1') | YES  |     | NULL              |                             |
+---------------+---------------+------+-----+-------------------+-----------------------------+
7 rows in set (0.38 sec)

mysql> SHOW TABLES;
+------------------+
| Tables_in_nb158d |
+------------------+
| practice         |
+------------------+
1 row in set (0.00 sec)

mysql> DESC `practice`;
+---------------+---------------+------+-----+-------------------+-----------------------------+
| Field         | Type          | Null | Key | Default           | Extra                       |
+---------------+---------------+------+-----+-------------------+-----------------------------+
| id            | int(11)       | NO   | PRI | NULL              | auto_increment              |
| name          | varchar(80)   | YES  |     | NULL              |                             |
| email         | varchar(100)  | YES  |     | NULL              |                             |
| password      | varchar(80)   | YES  |     | NULL              |                             |
| register_DATE | datetime      | YES  |     | NULL              |                             |
| modified_date | timestamp     | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| status        | enum('0','1') | YES  |     | NULL              |                             |
+---------------+---------------+------+-----+-------------------+-----------------------------+
7 rows in set (0.05 sec)

mysql> INSERT INTO `practice` VALUES(
     '1',
     'rasmus lerdorf',
     'zeev@andi.com',
     'admin',
     NOW(),
     NOW(),
     '1'
     );
Query OK, 1 row affected (0.31 sec)

mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2013-04-05 09:53:30 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT CURDATE();
+------------+
| CURDATE()  |
+------------+
| 2013-04-05 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT CURTIME();
+-----------+
| CURTIME() |
+-----------+
| 09:53:54  |
+-----------+
1 row in set (0.00 sec)

mysql> SELECT * FROM `practice`;
+----+----------------+---------------+----------+---------------------+---------------------+--------+
| id | name           | email         | password | register_DATE       | modified_date       | status |
+----+----------------+---------------+----------+---------------------+---------------------+--------+
|  1 | rasmus lerdorf | zeev@andi.com | admin    | 2013-04-05 09:53:04 | 2013-04-05 09:53:04 | 1      |
+----+----------------+---------------+----------+---------------------+---------------------+--------+
1 row in set (0.00 sec)

mysql> INSERT INTO `practice`
     (`name`,`email`,`password`,`register_date`,`status`)
     VALUES
     ('zeev suraski',
     'zeevsuraski@zend.com',
     '1q1q1q',
     NOW(),
     '1');
Query OK, 1 row affected (0.31 sec)

mysql> SELECT * FROM `practice`;
+----+----------------+----------------------+----------+---------------------+---------------------+--------+
| id | name           | email                | password | register_DATE       | modified_date       | status |
+----+----------------+----------------------+----------+---------------------+---------------------+--------+
|  1 | rasmus lerdorf | zeev@andi.com        | admin    | 2013-04-05 09:53:04 | 2013-04-05 09:53:04 | 1      |
|  2 | zeev suraski   | zeevsuraski@zend.com | 1q1q1q   | 2013-04-05 09:58:25 | 2013-04-05 09:58:25 | 1      |
+----+----------------+----------------------+----------+---------------------+---------------------+--------+
2 rows in set (0.00 sec)

mysql> INSERT INTO `practice` SET
     `name`='andigutmans@zend.com',
     `email`='andi@zend.com',
     `password`='danger',
     `register_date`=NOW(),
     `status`='0';
Query OK, 1 row affected (0.30 sec)

mysql> SELECT * FROM `practice`;
+----+----------------------+----------------------+----------+---------------------+---------------------+--------+
| id | name                 | email                | password | register_DATE       | modified_date       | status |
+----+----------------------+----------------------+----------+---------------------+---------------------+--------+
|  1 | rasmus lerdorf       | zeev@andi.com        | admin    | 2013-04-05 09:53:04 | 2013-04-05 09:53:04 | 1      |
|  2 | zeev suraski         | zeevsuraski@zend.com | 1q1q1q   | 2013-04-05 09:58:25 | 2013-04-05 09:58:25 | 1      |
|  3 | andigutmans@zend.com | andi@zend.com        | danger   | 2013-04-05 10:01:09 | 2013-04-05 10:01:09 | 0      |
+----+----------------------+----------------------+----------+---------------------+---------------------+--------+
3 rows in set (0.00 sec)

mysql>
